Returns the standard error of the predicted y-value for each x in the regression. The standard error is a measure of the amount of error in the prediction of y for an individual x.
Syntax
STEYX(known_y's,known_x's)
Known_y's is an array or range of dependent data points.
Known_x's is an array or range of independent data points.
Remarks
where x and y are the sample means AVERAGE(known_x’s) and AVERAGE(known_y’s), and n is the sample size.
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|